Ensure you have the 04 - projects_exercise.csv data loaded into a MongoDB collection.

Use this as an opportunity to explore the data, create your own queries.

For example, try to write MongoDB queries to find the following:
(If you get stuck just move on to the next question!)

The total number of records
The list of distinct Project Titles
The list of distinct Department Names
The list of distinct Employee Names
A list of just employee ids and names
The records with an hourly rate of less than 25
Employees sorted by hourly rate

Insert a new record for fictional values

Delete records for employee S. Smith

The average hourly rate

=== Answers ===

db.projects.count();

db.projects.distinct("Project Title ")

db.projects.distinct("Department Name ")

db.projects.find({}, {'Employee ID ': 1, 'Employee Name ': 1, '_id': 0})

db.projects.find({"Hourly Rate ": {$lt: 25}})

db.projects.find({}, {'Employee ID ': 1, 'Employee Name ': 1, '_id': 0}).sort("Hourly Rate ")

// this is complicated!
db.projects.aggregate([{$group: {"_id":"_id", AverageValue: { $avg: "$Hourly Rate " }}}])